Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ATAN

Syntax

Description of the illustration atan.gif

Purpose

`ATAN` returns the arc tangent of `n`. The argument `n` can be in an unbounded range and returns a value in the range of -pi/2 to pi/2, expressed in radians.

This function takes as an argument any numeric datatype or any nonnumeric datatype that can be implicitly converted to a numeric datatype. If the argument is `BINARY_FLOAT`, then the function returns `BINARY_DOUBLE`. Otherwise the function returns the same numeric datatype as the argument.

See Also: Table 2-10, "Implicit Type Conversion Matrix" for more information on implicit conversion

Examples

The following example returns the arc tangent of .3:

    SELECT ATAN(.3) "Arc_Tangent" FROM DUAL;

    Arc_Tangent
    ----------
    .291456794